[dbo].[Name_FRTeamInformation]

Property	Value
Created	11:09:00 AM Friday, August 06, 2010
Last Modified	11:40:04 AM Monday, February 20, 2012

Property

Value

Created

11:09:00 AM Friday, August 06, 2010

Last Modified

11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$	ID	varchar(10)	10
$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$	SEQN	int	4
	MEETING	varchar(10)	10
	TeamID	varchar(10)	10
	TeamName	varchar(100)	100
	TeamType	varchar(20)	20
	TeamGoal	money	8
	TeamCaptainAlternateId	varchar(50)	50

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$

varchar(10)

$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$

SEQN

int

MEETING

varchar(10)

TeamID

varchar(10)

TeamName

varchar(100)

100

TeamType

varchar(20)

TeamGoal

money

TeamCaptainAlternateId

varchar(50)

	Name	Columns	Unique
$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$	PK_Name_FRTeamInformation	ID, SEQN

Name

Columns

Unique

$Cluster Primary Key PK_Name_FRTeamInformation: ID\SEQN$

PK_Name_FRTeamInformation

ID, SEQN

SQL Script

CREATE TABLE [dbo].[Name_FRTeamInformation]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SEQN] [int] NOT NULL,
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TeamID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TeamName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TeamType] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TeamGoal] [money] NOT NULL,
[TeamCaptainAlternateId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_FRTeamInformation] ADD CONSTRAINT [PK_Name_FRTeamInformation] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO